| FaISIRNSLDSLoanSparseData |
| EntityType | Independent |
| Logical Entity Name | FaISIRNSLDSLoanSparseData |
| Default Table Name | FaISIRNSLDSLoanSparseData |
| Logical Only | NO |
| Owner | dbo |
| Definition | |
| Note |
| FaISIRNSLDSLoanSparseData Attributes |
| Attribute/Logical Rolename | Domain | Datatype | NULL | Definition |
FaISIRNSLDSLoanSparseDataId |
INTEGER | NO | ||
FaISIRMainId |
INTEGER | NO | ||
UserId |
INTEGER | NO | ||
| DateAdded | DATETIME | NO | ||
| DateLstMod | DATETIME | NO | ||
| ts | TIMESTAMP/DATE | NO | ||
| C800 | VARCHAR(max) | YES | ||
| C801 | VARCHAR(max) | YES | ||
| C802 | VARCHAR(max) | YES | ||
| C803 | VARCHAR(max) | YES | ||
| C804 | VARCHAR(max) | YES | ||
| C805 | VARCHAR(max) | YES | ||
| C806 | VARCHAR(max) | YES | ||
| C807 | VARCHAR(max) | YES | ||
| C808 | VARCHAR(max) | YES | ||
| C809 | VARCHAR(max) | YES | ||
| C810 | VARCHAR(max) | YES | ||
| C811 | VARCHAR(max) | YES | ||
| C812 | VARCHAR(max) | YES | ||
| C813 | VARCHAR(max) | YES | ||
| C814 | VARCHAR(max) | YES | ||
| C815 | VARCHAR(max) | YES | ||
| C816 | VARCHAR(max) | YES | ||
| C817 | VARCHAR(max) | YES | ||
| C818 | VARCHAR(max) | YES | ||
| C819 | VARCHAR(max) | YES | ||
| C820 | VARCHAR(max) | YES | ||
| C821 | VARCHAR(max) | YES | ||
| C822 | VARCHAR(max) | YES | ||
| C823 | VARCHAR(max) | YES | ||
| C824 | VARCHAR(max) | YES | ||
| C825 | VARCHAR(max) | YES | ||
| C826 | VARCHAR(max) | YES | ||
| C827 | VARCHAR(max) | YES | ||
| C828 | VARCHAR(max) | YES | ||
| C829 | VARCHAR(max) | YES | ||
| C830 | VARCHAR(max) | YES | ||
| C831 | VARCHAR(max) | YES | ||
| C832 | VARCHAR(max) | YES | ||
| C833 | VARCHAR(max) | YES | ||
| C834 | VARCHAR(max) | YES | ||
| C835 | VARCHAR(max) | YES | ||
| C836 | VARCHAR(max) | YES | ||
| C837 | VARCHAR(max) | YES | ||
| C838 | VARCHAR(max) | YES | ||
| C839 | VARCHAR(max) | YES | ||
| C840 | VARCHAR(max) | YES | ||
| C841 | VARCHAR(max) | YES | ||
| C842 | VARCHAR(max) | YES | ||
| C843 | VARCHAR(max) | YES | ||
| C844 | VARCHAR(max) | YES | ||
| C845 | VARCHAR(max) | YES | ||
| C846 | VARCHAR(max) | YES | ||
| C847 | VARCHAR(max) | YES | ||
| C848 | VARCHAR(max) | YES | ||
| C849 | VARCHAR(max) | YES | ||
| C850 | VARCHAR(max) | YES | ||
| C851 | VARCHAR(max) | YES | ||
| C852 | VARCHAR(max) | YES | ||
| C853 | VARCHAR(max) | YES | ||
| C854 | VARCHAR(max) | YES | ||
| C855 | VARCHAR(max) | YES | ||
| C856 | VARCHAR(max) | YES | ||
| C857 | VARCHAR(max) | YES | ||
| C858 | VARCHAR(max) | YES | ||
| C859 | VARCHAR(max) | YES | ||
| C860 | VARCHAR(max) | YES | ||
| C861 | VARCHAR(max) | YES | ||
| C862 | VARCHAR(max) | YES | ||
| C863 | VARCHAR(max) | YES | ||
| C864 | VARCHAR(max) | YES | ||
| C865 | VARCHAR(max) | YES | ||
| C866 | VARCHAR(max) | YES | ||
| C867 | VARCHAR(max) | YES | ||
| C868 | VARCHAR(max) | YES | ||
| C869 | VARCHAR(max) | YES | ||
| C870 | VARCHAR(max) | YES | ||
| C871 | VARCHAR(max) | YES | ||
| C872 | VARCHAR(max) | YES | ||
| C873 | VARCHAR(max) | YES | ||
| C874 | VARCHAR(max) | YES | ||
| C875 | VARCHAR(max) | YES | ||
| C876 | VARCHAR(max) | YES | ||
| C877 | VARCHAR(max) | YES | ||
| C878 | VARCHAR(max) | YES | ||
| C879 | VARCHAR(max) | YES | ||
| C880 | VARCHAR(max) | YES | ||
| C881 | VARCHAR(max) | YES | ||
| C882 | VARCHAR(max) | YES | ||
| C883 | VARCHAR(max) | YES | ||
| C884 | VARCHAR(max) | YES | ||
| C885 | VARCHAR(max) | YES | ||
| C886 | VARCHAR(max) | YES | ||
| C887 | VARCHAR(max) | YES | ||
| C888 | VARCHAR(max) | YES | ||
| C889 | VARCHAR(max) | YES | ||
| C890 | VARCHAR(max) | YES | ||
| C891 | VARCHAR(max) | YES | ||
| C892 | VARCHAR(max) | YES | ||
| C893 | VARCHAR(max) | YES | ||
| C894 | VARCHAR(max) | YES | ||
| C895 | VARCHAR(max) | YES | ||
| C896 | VARCHAR(max) | YES | ||
| C897 | VARCHAR(max) | YES | ||
| C898 | VARCHAR(max) | YES | ||
| C899 | VARCHAR(max) | YES | ||
| C900 | VARCHAR(max) | YES | ||
| C901 | VARCHAR(max) | YES | ||
| C902 | VARCHAR(max) | YES | ||
| C903 | VARCHAR(max) | YES | ||
| C904 | VARCHAR(max) | YES | ||
| C905 | VARCHAR(max) | YES | ||
| C906 | VARCHAR(max) | YES | ||
| C907 | VARCHAR(max) | YES | ||
| C908 | VARCHAR(max) | YES | ||
| C909 | VARCHAR(max) | YES | ||
| C910 | VARCHAR(max) | YES | ||
| C911 | VARCHAR(max) | YES | ||
| C912 | VARCHAR(max) | YES | ||
| C913 | VARCHAR(max) | YES | ||
| C914 | VARCHAR(max) | YES | ||
| C915 | VARCHAR(max) | YES | ||
| C916 | VARCHAR(max) | YES | ||
| C917 | VARCHAR(max) | YES | ||
| C918 | VARCHAR(max) | YES | ||
| C919 | VARCHAR(max) | YES | ||
| C920 | VARCHAR(max) | YES | ||
| C921 | VARCHAR(max) | YES | ||
| C922 | VARCHAR(max) | YES | ||
| C923 | VARCHAR(max) | YES | ||
| C924 | VARCHAR(max) | YES | ||
| C925 | VARCHAR(max) | YES | ||
| C926 | VARCHAR(max) | YES | ||
| C927 | VARCHAR(max) | YES | ||
| C928 | VARCHAR(max) | YES | ||
| C929 | VARCHAR(max) | YES | ||
| C930 | VARCHAR(max) | YES | ||
| C931 | VARCHAR(max) | YES | ||
| C932 | VARCHAR(max) | YES | ||
| C933 | VARCHAR(max) | YES | ||
| C934 | VARCHAR(max) | YES | ||
| C935 | VARCHAR(max) | YES | ||
| C936 | VARCHAR(max) | YES | ||
| C937 | VARCHAR(max) | YES | ||
| C938 | VARCHAR(max) | YES | ||
| C939 | VARCHAR(max) | YES | ||
| C940 | VARCHAR(max) | YES | ||
| C941 | VARCHAR(max) | YES | ||
| C942 | VARCHAR(max) | YES | ||
| C943 | VARCHAR(max) | YES | ||
| C944 | VARCHAR(max) | YES | ||
| C945 | VARCHAR(max) | YES | ||
| C946 | VARCHAR(max) | YES | ||
| C947 | VARCHAR(max) | YES | ||
| C948 | VARCHAR(max) | YES | ||
| C949 | VARCHAR(max) | YES | ||
| C950 | VARCHAR(max) | YES | ||
| C951 | VARCHAR(max) | YES | ||
| C952 | VARCHAR(max) | YES | ||
| C953 | VARCHAR(max) | YES | ||
| C954 | VARCHAR(max) | YES | ||
| C955 | VARCHAR(max) | YES | ||
| C956 | VARCHAR(max) | YES | ||
| C957 | VARCHAR(max) | YES | ||
| C958 | VARCHAR(max) | YES | ||
| C959 | VARCHAR(max) | YES | ||
| C960 | VARCHAR(max) | YES | ||
| C961 | VARCHAR(max) | YES | ||
| C962 | VARCHAR(max) | YES | ||
| C963 | VARCHAR(max) | YES | ||
| C964 | VARCHAR(max) | YES | ||
| C965 | VARCHAR(max) | YES | ||
| C966 | VARCHAR(max) | YES | ||
| C967 | VARCHAR(max) | YES | ||
| C968 | VARCHAR(max) | YES | ||
| C969 | VARCHAR(max) | YES | ||
| C970 | VARCHAR(max) | YES | ||
| C971 | VARCHAR(max) | YES | ||
| C972 | VARCHAR(max) | YES | ||
| C973 | VARCHAR(max) | YES | ||
| C974 | VARCHAR(max) | YES | ||
| C975 | VARCHAR(max) | YES | ||
| C976 | VARCHAR(max) | YES | ||
| C977 | VARCHAR(max) | YES | ||
| C978 | VARCHAR(max) | YES | ||
| C979 | VARCHAR(max) | YES | ||
| C980 | VARCHAR(max) | YES | ||
| C981 | VARCHAR(max) | YES | ||
| C982 | VARCHAR(max) | YES | ||
| C983 | VARCHAR(max) | YES | ||
| C984 | VARCHAR(max) | YES | ||
| C985 | VARCHAR(max) | YES | ||
| C986 | VARCHAR(max) | YES | ||
| C987 | VARCHAR(max) | YES | ||
| C988 | VARCHAR(max) | YES | ||
| C989 | VARCHAR(max) | YES | ||
| C990 | VARCHAR(max) | YES | ||
| C991 | VARCHAR(max) | YES | ||
| C992 | VARCHAR(max) | YES | ||
| C993 | VARCHAR(max) | YES | ||
| C994 | VARCHAR(max) | YES | ||
| C995 | VARCHAR(max) | YES | ||
| C996 | VARCHAR(max) | YES | ||
| C997 | VARCHAR(max) | YES | ||
| C998 | VARCHAR(max) | YES | ||
| C999 | VARCHAR(max) | YES | ||
| C1000 | VARCHAR(max) | YES | ||
| C1001 | VARCHAR(max) | YES | ||
| C1002 | VARCHAR(max) | YES | ||
| C1003 | VARCHAR(max) | YES | ||
| C1004 | VARCHAR(max) | YES | ||
| C1005 | VARCHAR(max) | YES | ||
| C1006 | VARCHAR(max) | YES | ||
| C1007 | VARCHAR(max) | YES | ||
| C1008 | VARCHAR(max) | YES | ||
| C1009 | VARCHAR(max) | YES | ||
| C1010 | VARCHAR(max) | YES | ||
| C1011 | VARCHAR(max) | YES | ||
| C1012 | VARCHAR(max) | YES | ||
| C1013 | VARCHAR(max) | YES | ||
| C1014 | VARCHAR(max) | YES | ||
| C1015 | VARCHAR(max) | YES | ||
| C1016 | VARCHAR(max) | YES | ||
| C1017 | VARCHAR(max) | YES | ||
| C1018 | VARCHAR(max) | YES | ||
| C1019 | VARCHAR(max) | YES | ||
| C1020 | VARCHAR(max) | YES | ||
| C1021 | VARCHAR(max) | YES | ||
| C1022 | VARCHAR(max) | YES | ||
| C1023 | VARCHAR(max) | YES | ||
| C1024 | VARCHAR(max) | YES | ||
| C1025 | VARCHAR(max) | YES | ||
| C1026 | VARCHAR(max) | YES | ||
| C1027 | VARCHAR(max) | YES | ||
| C1028 | VARCHAR(max) | YES | ||
| C1029 | VARCHAR(max) | YES | ||
| C1030 | VARCHAR(max) | YES | ||
| C1031 | VARCHAR(max) | YES | ||
| C1032 | VARCHAR(max) | YES | ||
| C1033 | VARCHAR(max) | YES | ||
| C1034 | VARCHAR(max) | YES | ||
| C1035 | VARCHAR(max) | YES | ||
| C1036 | VARCHAR(max) | YES | ||
| C1037 | VARCHAR(max) | YES | ||
| C1038 | VARCHAR(max) | YES | ||
| C1039 | VARCHAR(max) | YES | ||
| C1040 | VARCHAR(max) | YES | ||
| C1041 | VARCHAR(max) | YES | ||
| C1042 | VARCHAR(max) | YES | ||
| C1043 | VARCHAR(max) | YES | ||
| C1044 | VARCHAR(max) | YES | ||
| C1045 | VARCHAR(max) | YES | ||
| C1046 | VARCHAR(max) | YES | ||
| C1047 | VARCHAR(max) | YES | ||
| C1048 | VARCHAR(max) | YES | ||
| C1049 | VARCHAR(max) | YES |
| FaISIRNSLDSLoanSparseData Keys |
| Key Name | Key Type | Keys |
| UK_FaISIRNSLDSLoanSparseData_FaISIRMainId | Alternate Key | FaISIRMainId |
| Pk_FaISIRNSLDSLoanSparseData_FaISIRNSLDSLoanSparseDataId | PrimaryKey | FaISIRNSLDSLoanSparseDataId |
| FaISIRNSLDSLoanSparseData Relationships |
| Parent Relationships: |
| Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype |
| IsirSummary | Non-Identifying | One To Zero or More | FaISIRMainId | NO | |||
| Staff | Non-Identifying | One To Zero or More | UserId | NO |
| Child Relationships: |
| Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype |
| FaISIRNSLDSLoanSparseData Check Constraints |
| Check Constraint Name | CheckConstraint |
| FaISIRNSLDSLoanSparseData Where Used - Model Usage |
| Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments |
| Logical dbo.FaISIRNSLDSLoanSparseData |
NO | |||
| Physical (Microsoft SQL Server) dbo.FaISIRNSLDSLoanSparseData |
NO |
| FaISIRNSLDSLoanSparseData Where Used - Submodel Usage |
| Model | Submodel Usage |
| Logical | Main Model |
| Physical (Microsoft SQL Server) | Main Model |
| Physical (Microsoft SQL Server) | Financial Aid |
| FaISIRNSLDSLoanSparseData Data Movement Rules |
| Name | Type | Rule Text/Value |